Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 9994 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.6 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Numeric | 6 |
|---|---|
| Text | 6 |
| DateTime | 2 |
| Categorical | 7 |
Country has constant value "United States" | Constant |
Category is highly overall correlated with Sub-Category | High correlation |
Discount is highly overall correlated with Profit | High correlation |
Postal Code is highly overall correlated with Region and 1 other fields | High correlation |
Profit is highly overall correlated with Discount and 1 other fields | High correlation |
Region is highly overall correlated with Postal Code and 1 other fields | High correlation |
Sales is highly overall correlated with Profit | High correlation |
State is highly overall correlated with Postal Code and 1 other fields | High correlation |
Sub-Category is highly overall correlated with Category | High correlation |
Row ID is uniformly distributed | Uniform |
Row ID has unique values | Unique |
Discount has 4798 (48.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-01-01 15:46:58.232708 |
|---|---|
| Analysis finished | 2025-01-01 15:47:06.566756 |
| Duration | 8.33 seconds |
| Software version | ydata-profiling vv4.12.1 |
| Download configuration | config.json |
Variables
Row ID
Real number (ℝ)
Uniform Unique
| Distinct | 9994 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4997.5 |
| Minimum | 1 |
|---|---|
| Maximum | 9994 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 500.65 |
| Q1 | 2499.25 |
| median | 4997.5 |
| Q3 | 7495.75 |
| 95-th percentile | 9494.35 |
| Maximum | 9994 |
| Range | 9993 |
| Interquartile range (IQR) | 4996.5 |
Descriptive statistics
| Standard deviation | 2885.1636 |
|---|---|
| Coefficient of variation (CV) | 0.57732139 |
| Kurtosis | -1.2 |
| Mean | 4997.5 |
| Median Absolute Deviation (MAD) | 2498.5 |
| Skewness | 0 |
| Sum | 49945015 |
| Variance | 8324169.2 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 6666 | 1 | < 0.1% |
| 6659 | 1 | < 0.1% |
| 6660 | 1 | < 0.1% |
| 6661 | 1 | < 0.1% |
| 6662 | 1 | < 0.1% |
| 6663 | 1 | < 0.1% |
| 6664 | 1 | < 0.1% |
| 6665 | 1 | < 0.1% |
| 6667 | 1 | < 0.1% |
| Other values (9984) | 9984 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 9994 | 1 | |
| 9993 | 1 | |
| 9992 | 1 | |
| 9991 | 1 | |
| 9990 | 1 | |
| 9989 | 1 | |
| 9988 | 1 | |
| 9987 | 1 | |
| 9986 | 1 | |
| 9985 | 1 |
Order ID
Text
| Distinct | 5009 |
|---|---|
| Distinct (%) | 50.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Unique
| Unique | 2538 ? |
|---|---|
| Unique (%) | 25.4% |
Sample
| 1st row | CA-2016-152156 |
|---|---|
| 2nd row | CA-2016-152156 |
| 3rd row | CA-2016-138688 |
| 4th row | US-2015-108966 |
| 5th row | US-2015-108966 |
| Value | Count | Frequency (%) |
| ca-2017-100111 | 14 | 0.1% |
| ca-2017-157987 | 12 | 0.1% |
| ca-2016-165330 | 11 | 0.1% |
| us-2016-108504 | 11 | 0.1% |
| ca-2015-131338 | 10 | 0.1% |
| ca-2016-105732 | 10 | 0.1% |
| us-2015-126977 | 10 | 0.1% |
| us-2015-163433 | 9 | 0.1% |
| ca-2017-140949 | 9 | 0.1% |
| ca-2015-158421 | 9 | 0.1% |
| Other values (4999) | 9889 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 25510 | |
| - | 19988 | |
| 0 | 15492 | |
| 2 | 15381 | |
| C | 8308 | 5.9% |
| A | 8308 | 5.9% |
| 6 | 7904 | 5.6% |
| 7 | 7438 | 5.3% |
| 4 | 7400 | 5.3% |
| 5 | 7338 | 5.2% |
| Other values (5) | 16849 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 139916 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 25510 | |
| - | 19988 | |
| 0 | 15492 | |
| 2 | 15381 | |
| C | 8308 | 5.9% |
| A | 8308 | 5.9% |
| 6 | 7904 | 5.6% |
| 7 | 7438 | 5.3% |
| 4 | 7400 | 5.3% |
| 5 | 7338 | 5.2% |
| Other values (5) | 16849 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 139916 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 25510 | |
| - | 19988 | |
| 0 | 15492 | |
| 2 | 15381 | |
| C | 8308 | 5.9% |
| A | 8308 | 5.9% |
| 6 | 7904 | 5.6% |
| 7 | 7438 | 5.3% |
| 4 | 7400 | 5.3% |
| 5 | 7338 | 5.2% |
| Other values (5) | 16849 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 139916 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 25510 | |
| - | 19988 | |
| 0 | 15492 | |
| 2 | 15381 | |
| C | 8308 | 5.9% |
| A | 8308 | 5.9% |
| 6 | 7904 | 5.6% |
| 7 | 7438 | 5.3% |
| 4 | 7400 | 5.3% |
| 5 | 7338 | 5.2% |
| Other values (5) | 16849 |
Order Date
Date
| Distinct | 1237 |
|---|---|
| Distinct (%) | 12.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| Minimum | 2014-01-03 00:00:00 |
|---|---|
| Maximum | 2017-12-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Ship Date
Date
| Distinct | 1334 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| Minimum | 2014-01-07 00:00:00 |
|---|---|
| Maximum | 2018-01-05 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Ship Mode
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 543 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.823094 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Second Class |
|---|---|
| 2nd row | Second Class |
| 3rd row | Second Class |
| 4th row | Standard Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 5968 | |
| Second Class | 1945 | 19.5% |
| First Class | 1538 | 15.4% |
| Same Day | 543 | 5.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 9451 | |
| standard | 5968 | |
| second | 1945 | 9.7% |
| first | 1538 | 7.7% |
| same | 543 | 2.7% |
| day | 543 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| 9994 | ||
| l | 9451 | |
| C | 9451 | |
| S | 8456 | 6.6% |
| n | 7913 | 6.2% |
| r | 7506 | 5.9% |
| t | 7506 | 5.9% |
| Other values (8) | 11083 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 128154 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| 9994 | ||
| l | 9451 | |
| C | 9451 | |
| S | 8456 | 6.6% |
| n | 7913 | 6.2% |
| r | 7506 | 5.9% |
| t | 7506 | 5.9% |
| Other values (8) | 11083 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 128154 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| 9994 | ||
| l | 9451 | |
| C | 9451 | |
| S | 8456 | 6.6% |
| n | 7913 | 6.2% |
| r | 7506 | 5.9% |
| t | 7506 | 5.9% |
| Other values (8) | 11083 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 128154 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| 9994 | ||
| l | 9451 | |
| C | 9451 | |
| S | 8456 | 6.6% |
| n | 7913 | 6.2% |
| r | 7506 | 5.9% |
| t | 7506 | 5.9% |
| Other values (8) | 11083 |
Customer ID
Text
| Distinct | 793 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | CG-12520 |
|---|---|
| 2nd row | CG-12520 |
| 3rd row | DV-13045 |
| 4th row | SO-20335 |
| 5th row | SO-20335 |
| Value | Count | Frequency (%) |
| wb-21850 | 37 | 0.4% |
| ma-17560 | 34 | 0.3% |
| pp-18955 | 34 | 0.3% |
| jl-15835 | 34 | 0.3% |
| ck-12205 | 32 | 0.3% |
| sv-20365 | 32 | 0.3% |
| jd-15895 | 32 | 0.3% |
| eh-13765 | 32 | 0.3% |
| zc-21910 | 31 | 0.3% |
| ep-13915 | 31 | 0.3% |
| Other values (783) | 9665 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 11915 | |
| - | 9994 | |
| 0 | 8532 | 10.7% |
| 5 | 7865 | 9.8% |
| 2 | 4682 | 5.9% |
| 7 | 2931 | 3.7% |
| 6 | 2909 | 3.6% |
| 9 | 2904 | 3.6% |
| 8 | 2818 | 3.5% |
| 3 | 2779 | 3.5% |
| Other values (30) | 22623 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 79952 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 11915 | |
| - | 9994 | |
| 0 | 8532 | 10.7% |
| 5 | 7865 | 9.8% |
| 2 | 4682 | 5.9% |
| 7 | 2931 | 3.7% |
| 6 | 2909 | 3.6% |
| 9 | 2904 | 3.6% |
| 8 | 2818 | 3.5% |
| 3 | 2779 | 3.5% |
| Other values (30) | 22623 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 79952 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 11915 | |
| - | 9994 | |
| 0 | 8532 | 10.7% |
| 5 | 7865 | 9.8% |
| 2 | 4682 | 5.9% |
| 7 | 2931 | 3.7% |
| 6 | 2909 | 3.6% |
| 9 | 2904 | 3.6% |
| 8 | 2818 | 3.5% |
| 3 | 2779 | 3.5% |
| Other values (30) | 22623 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 79952 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 11915 | |
| - | 9994 | |
| 0 | 8532 | 10.7% |
| 5 | 7865 | 9.8% |
| 2 | 4682 | 5.9% |
| 7 | 2931 | 3.7% |
| 6 | 2909 | 3.6% |
| 9 | 2904 | 3.6% |
| 8 | 2818 | 3.5% |
| 3 | 2779 | 3.5% |
| Other values (30) | 22623 |
Customer Name
Text
| Distinct | 793 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 18 |
| Mean length | 12.960676 |
| Min length | 7 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Claire Gute |
|---|---|
| 2nd row | Claire Gute |
| 3rd row | Darrin Van Huff |
| 4th row | Sean O'Donnell |
| 5th row | Sean O'Donnell |
| Value | Count | Frequency (%) |
| michael | 120 | 0.6% |
| frank | 112 | 0.6% |
| john | 107 | 0.5% |
| patrick | 96 | 0.5% |
| brian | 93 | 0.5% |
| stewart | 93 | 0.5% |
| paul | 92 | 0.5% |
| ken | 91 | 0.5% |
| rick | 91 | 0.5% |
| matt | 86 | 0.4% |
| Other values (901) | 19072 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 12011 | 9.3% |
| e | 11836 | 9.1% |
| n | 10241 | 7.9% |
| 10059 | 7.8% | |
| r | 9530 | 7.4% |
| i | 7919 | 6.1% |
| l | 6494 | 5.0% |
| o | 5850 | 4.5% |
| t | 5435 | 4.2% |
| s | 4546 | 3.5% |
| Other values (47) | 45608 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 129529 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 12011 | 9.3% |
| e | 11836 | 9.1% |
| n | 10241 | 7.9% |
| 10059 | 7.8% | |
| r | 9530 | 7.4% |
| i | 7919 | 6.1% |
| l | 6494 | 5.0% |
| o | 5850 | 4.5% |
| t | 5435 | 4.2% |
| s | 4546 | 3.5% |
| Other values (47) | 45608 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 129529 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 12011 | 9.3% |
| e | 11836 | 9.1% |
| n | 10241 | 7.9% |
| 10059 | 7.8% | |
| r | 9530 | 7.4% |
| i | 7919 | 6.1% |
| l | 6494 | 5.0% |
| o | 5850 | 4.5% |
| t | 5435 | 4.2% |
| s | 4546 | 3.5% |
| Other values (47) | 45608 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 129529 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 12011 | 9.3% |
| e | 11836 | 9.1% |
| n | 10241 | 7.9% |
| 10059 | 7.8% | |
| r | 9530 | 7.4% |
| i | 7919 | 6.1% |
| l | 6494 | 5.0% |
| o | 5850 | 4.5% |
| t | 5435 | 4.2% |
| s | 4546 | 3.5% |
| Other values (47) | 45608 |
Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.8374024 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Corporate |
| 4th row | Consumer |
| 5th row | Consumer |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 5191 | |
| Corporate | 3020 | |
| Home Office | 1783 | 17.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 5191 | |
| corporate | 3020 | |
| home | 1783 | 15.1% |
| office | 1783 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| n | 5191 | 5.9% |
| s | 5191 | 5.9% |
| u | 5191 | 5.9% |
| f | 3566 | 4.0% |
| t | 3020 | 3.4% |
| Other values (7) | 14955 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 88321 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| n | 5191 | 5.9% |
| s | 5191 | 5.9% |
| u | 5191 | 5.9% |
| f | 3566 | 4.0% |
| t | 3020 | 3.4% |
| Other values (7) | 14955 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 88321 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| n | 5191 | 5.9% |
| s | 5191 | 5.9% |
| u | 5191 | 5.9% |
| f | 3566 | 4.0% |
| t | 3020 | 3.4% |
| Other values (7) | 14955 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 88321 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| n | 5191 | 5.9% |
| s | 5191 | 5.9% |
| u | 5191 | 5.9% |
| f | 3566 | 4.0% |
| t | 3020 | 3.4% |
| Other values (7) | 14955 |
Country
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| United States |
|---|
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United States |
|---|---|
| 2nd row | United States |
| 3rd row | United States |
| 4th row | United States |
| 5th row | United States |
Common Values
| Value | Count | Frequency (%) |
| United States | 9994 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 9994 | |
| states | 9994 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| U | 9994 | 7.7% |
| n | 9994 | 7.7% |
| i | 9994 | 7.7% |
| d | 9994 | 7.7% |
| 9994 | 7.7% | |
| S | 9994 | 7.7% |
| a | 9994 | 7.7% |
| s | 9994 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 129922 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| U | 9994 | 7.7% |
| n | 9994 | 7.7% |
| i | 9994 | 7.7% |
| d | 9994 | 7.7% |
| 9994 | 7.7% | |
| S | 9994 | 7.7% |
| a | 9994 | 7.7% |
| s | 9994 | 7.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 129922 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| U | 9994 | 7.7% |
| n | 9994 | 7.7% |
| i | 9994 | 7.7% |
| d | 9994 | 7.7% |
| 9994 | 7.7% | |
| S | 9994 | 7.7% |
| a | 9994 | 7.7% |
| s | 9994 | 7.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 129922 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| U | 9994 | 7.7% |
| n | 9994 | 7.7% |
| i | 9994 | 7.7% |
| d | 9994 | 7.7% |
| 9994 | 7.7% | |
| S | 9994 | 7.7% |
| a | 9994 | 7.7% |
| s | 9994 | 7.7% |
City
Text
| Distinct | 531 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 9.3306984 |
| Min length | 4 |
Unique
| Unique | 70 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | Henderson |
|---|---|
| 2nd row | Henderson |
| 3rd row | Los Angeles |
| 4th row | Fort Lauderdale |
| 5th row | Fort Lauderdale |
| Value | Count | Frequency (%) |
| city | 994 | 7.0% |
| new | 937 | 6.6% |
| york | 920 | 6.5% |
| san | 805 | 5.7% |
| los | 747 | 5.2% |
| angeles | 747 | 5.2% |
| philadelphia | 537 | 3.8% |
| francisco | 510 | 3.6% |
| seattle | 428 | 3.0% |
| houston | 377 | 2.6% |
| Other values (555) | 7234 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 8719 | 9.4% |
| a | 7591 | 8.1% |
| o | 7499 | 8.0% |
| i | 6229 | 6.7% |
| n | 6199 | 6.6% |
| l | 5986 | 6.4% |
| s | 4699 | 5.0% |
| r | 4468 | 4.8% |
| t | 4438 | 4.8% |
| 4242 | 4.5% | |
| Other values (41) | 33181 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 93251 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 8719 | 9.4% |
| a | 7591 | 8.1% |
| o | 7499 | 8.0% |
| i | 6229 | 6.7% |
| n | 6199 | 6.6% |
| l | 5986 | 6.4% |
| s | 4699 | 5.0% |
| r | 4468 | 4.8% |
| t | 4438 | 4.8% |
| 4242 | 4.5% | |
| Other values (41) | 33181 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 93251 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 8719 | 9.4% |
| a | 7591 | 8.1% |
| o | 7499 | 8.0% |
| i | 6229 | 6.7% |
| n | 6199 | 6.6% |
| l | 5986 | 6.4% |
| s | 4699 | 5.0% |
| r | 4468 | 4.8% |
| t | 4438 | 4.8% |
| 4242 | 4.5% | |
| Other values (41) | 33181 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 93251 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 8719 | 9.4% |
| a | 7591 | 8.1% |
| o | 7499 | 8.0% |
| i | 6229 | 6.7% |
| n | 6199 | 6.6% |
| l | 5986 | 6.4% |
| s | 4699 | 5.0% |
| r | 4468 | 4.8% |
| t | 4438 | 4.8% |
| 4242 | 4.5% | |
| Other values (41) | 33181 |
State
Categorical
High correlation
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| California | |
|---|---|
| New York | |
| Texas | |
| Pennsylvania | |
| Washington | |
| Other values (44) |
Length
| Max length | 20 |
|---|---|
| Median length | 14 |
| Mean length | 8.4871923 |
| Min length | 4 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Kentucky |
|---|---|
| 2nd row | Kentucky |
| 3rd row | California |
| 4th row | Florida |
| 5th row | Florida |
Common Values
| Value | Count | Frequency (%) |
| California | 2001 | |
| New York | 1128 | 11.3% |
| Texas | 985 | 9.9% |
| Pennsylvania | 587 | 5.9% |
| Washington | 506 | 5.1% |
| Illinois | 492 | 4.9% |
| Ohio | 469 | 4.7% |
| Florida | 383 | 3.8% |
| Michigan | 255 | 2.6% |
| North Carolina | 249 | 2.5% |
| Other values (39) | 2939 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| california | 2001 | |
| new | 1322 | 11.3% |
| york | 1128 | 9.6% |
| texas | 985 | 8.4% |
| pennsylvania | 587 | 5.0% |
| washington | 506 | 4.3% |
| illinois | 492 | 4.2% |
| ohio | 469 | 4.0% |
| florida | 383 | 3.3% |
| carolina | 291 | 2.5% |
| Other values (43) | 3542 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | 9.5% |
| o | 7323 | 8.6% |
| r | 5544 | 6.5% |
| e | 5051 | 6.0% |
| l | 4822 | 5.7% |
| s | 4604 | 5.4% |
| C | 2566 | 3.0% |
| f | 2011 | 2.4% |
| Other values (36) | 24157 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84821 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | 9.5% |
| o | 7323 | 8.6% |
| r | 5544 | 6.5% |
| e | 5051 | 6.0% |
| l | 4822 | 5.7% |
| s | 4604 | 5.4% |
| C | 2566 | 3.0% |
| f | 2011 | 2.4% |
| Other values (36) | 24157 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84821 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | 9.5% |
| o | 7323 | 8.6% |
| r | 5544 | 6.5% |
| e | 5051 | 6.0% |
| l | 4822 | 5.7% |
| s | 4604 | 5.4% |
| C | 2566 | 3.0% |
| f | 2011 | 2.4% |
| Other values (36) | 24157 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84821 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | 9.5% |
| o | 7323 | 8.6% |
| r | 5544 | 6.5% |
| e | 5051 | 6.0% |
| l | 4822 | 5.7% |
| s | 4604 | 5.4% |
| C | 2566 | 3.0% |
| f | 2011 | 2.4% |
| Other values (36) | 24157 |
Postal Code
Real number (ℝ)
High correlation
| Distinct | 631 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55190.379 |
| Minimum | 1040 |
|---|---|
| Maximum | 99301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 1040 |
|---|---|
| 5-th percentile | 10009 |
| Q1 | 23223 |
| median | 56430.5 |
| Q3 | 90008 |
| 95-th percentile | 98006 |
| Maximum | 99301 |
| Range | 98261 |
| Interquartile range (IQR) | 66785 |
Descriptive statistics
| Standard deviation | 32063.693 |
|---|---|
| Coefficient of variation (CV) | 0.58096526 |
| Kurtosis | -1.4930202 |
| Mean | 55190.379 |
| Median Absolute Deviation (MAD) | 33573.5 |
| Skewness | -0.12852552 |
| Sum | 5.5157265 × 108 |
| Variance | 1.0280804 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10035 | 263 | 2.6% |
| 10024 | 230 | 2.3% |
| 10009 | 229 | 2.3% |
| 94122 | 203 | 2.0% |
| 10011 | 193 | 1.9% |
| 94110 | 166 | 1.7% |
| 98105 | 165 | 1.7% |
| 19134 | 160 | 1.6% |
| 98103 | 151 | 1.5% |
| 90049 | 151 | 1.5% |
| Other values (621) | 8083 |
| Value | Count | Frequency (%) |
| 1040 | 1 | < 0.1% |
| 1453 | 6 | 0.1% |
| 1752 | 2 | < 0.1% |
| 1810 | 4 | < 0.1% |
| 1841 | 33 | |
| 1852 | 16 | |
| 1915 | 3 | < 0.1% |
| 2038 | 17 | |
| 2138 | 6 | 0.1% |
| 2148 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99301 | 6 | 0.1% |
| 99207 | 7 | 0.1% |
| 98661 | 5 | 0.1% |
| 98632 | 3 | < 0.1% |
| 98502 | 5 | 0.1% |
| 98270 | 2 | < 0.1% |
| 98226 | 3 | < 0.1% |
| 98208 | 1 | < 0.1% |
| 98198 | 7 | 0.1% |
| 98115 | 112 |
Region
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| West | |
|---|---|
| East | |
| Central | |
| South |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.8594156 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South |
|---|---|
| 2nd row | South |
| 3rd row | West |
| 4th row | South |
| 5th row | South |
Common Values
| Value | Count | Frequency (%) |
| West | 3203 | |
| East | 2848 | |
| Central | 2323 | |
| South | 1620 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| west | 3203 | |
| east | 2848 | |
| central | 2323 | |
| south | 1620 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 48565 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 48565 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 48565 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Product ID
Text
| Distinct | 1862 |
|---|---|
| Distinct (%) | 18.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Unique
| Unique | 91 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | FUR-BO-10001798 |
|---|---|
| 2nd row | FUR-CH-10000454 |
| 3rd row | OFF-LA-10000240 |
| 4th row | FUR-TA-10000577 |
| 5th row | OFF-ST-10000760 |
| Value | Count | Frequency (%) |
| off-pa-10001970 | 19 | 0.2% |
| tec-ac-10003832 | 18 | 0.2% |
| fur-fu-10004270 | 16 | 0.2% |
| fur-ch-10001146 | 15 | 0.2% |
| tec-ac-10003628 | 15 | 0.2% |
| fur-ch-10002647 | 15 | 0.2% |
| tec-ac-10002049 | 15 | 0.2% |
| off-pa-10002377 | 14 | 0.1% |
| fur-ch-10003774 | 14 | 0.1% |
| off-bi-10002026 | 14 | 0.1% |
| Other values (1852) | 9839 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 35052 | |
| - | 19988 | |
| F | 15347 | |
| 1 | 14995 | |
| O | 6322 | 4.2% |
| 2 | 4862 | 3.2% |
| 4 | 4831 | 3.2% |
| 3 | 4805 | 3.2% |
| A | 4422 | 2.9% |
| 5 | 3401 | 2.3% |
| Other values (17) | 35885 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 149910 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 35052 | |
| - | 19988 | |
| F | 15347 | |
| 1 | 14995 | |
| O | 6322 | 4.2% |
| 2 | 4862 | 3.2% |
| 4 | 4831 | 3.2% |
| 3 | 4805 | 3.2% |
| A | 4422 | 2.9% |
| 5 | 3401 | 2.3% |
| Other values (17) | 35885 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 149910 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 35052 | |
| - | 19988 | |
| F | 15347 | |
| 1 | 14995 | |
| O | 6322 | 4.2% |
| 2 | 4862 | 3.2% |
| 4 | 4831 | 3.2% |
| 3 | 4805 | 3.2% |
| A | 4422 | 2.9% |
| 5 | 3401 | 2.3% |
| Other values (17) | 35885 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 149910 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 35052 | |
| - | 19988 | |
| F | 15347 | |
| 1 | 14995 | |
| O | 6322 | 4.2% |
| 2 | 4862 | 3.2% |
| 4 | 4831 | 3.2% |
| 3 | 4805 | 3.2% |
| A | 4422 | 2.9% |
| 5 | 3401 | 2.3% |
| Other values (17) | 35885 |
Category
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| Office Supplies | |
|---|---|
| Furniture | |
| Technology |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 12.802582 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Furniture |
|---|---|
| 2nd row | Furniture |
| 3rd row | Office Supplies |
| 4th row | Furniture |
| 5th row | Office Supplies |
Common Values
| Value | Count | Frequency (%) |
| Office Supplies | 6026 | |
| Furniture | 2121 | 21.2% |
| Technology | 1847 | 18.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| office | 6026 | |
| supplies | 6026 | |
| furniture | 2121 | 13.2% |
| technology | 1847 | 11.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | 8.0% |
| c | 7873 | 6.2% |
| l | 7873 | 6.2% |
| O | 6026 | 4.7% |
| s | 6026 | 4.7% |
| S | 6026 | 4.7% |
| Other values (10) | 29560 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 127949 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | 8.0% |
| c | 7873 | 6.2% |
| l | 7873 | 6.2% |
| O | 6026 | 4.7% |
| s | 6026 | 4.7% |
| S | 6026 | 4.7% |
| Other values (10) | 29560 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 127949 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | 8.0% |
| c | 7873 | 6.2% |
| l | 7873 | 6.2% |
| O | 6026 | 4.7% |
| s | 6026 | 4.7% |
| S | 6026 | 4.7% |
| Other values (10) | 29560 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 127949 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | 8.0% |
| c | 7873 | 6.2% |
| l | 7873 | 6.2% |
| O | 6026 | 4.7% |
| s | 6026 | 4.7% |
| S | 6026 | 4.7% |
| Other values (10) | 29560 |
Sub-Category
Categorical
High correlation
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
| Binders | |
|---|---|
| Paper | |
| Furnishings | |
| Phones | |
| Storage | |
| Other values (12) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 7.191715 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bookcases |
|---|---|
| 2nd row | Chairs |
| 3rd row | Labels |
| 4th row | Tables |
| 5th row | Storage |
Common Values
| Value | Count | Frequency (%) |
| Binders | 1523 | |
| Paper | 1370 | |
| Furnishings | 957 | |
| Phones | 889 | |
| Storage | 846 | |
| Art | 796 | |
| Accessories | 775 | |
| Chairs | 617 | |
| Appliances | 466 | 4.7% |
| Labels | 364 | 3.6% |
| Other values (7) | 1391 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| binders | 1523 | |
| paper | 1370 | |
| furnishings | 957 | |
| phones | 889 | |
| storage | 846 | |
| art | 796 | |
| accessories | 775 | |
| chairs | 617 | |
| appliances | 466 | 4.7% |
| labels | 364 | 3.6% |
| Other values (7) | 1391 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 71874 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 71874 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 71874 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Product Name
Text
| Distinct | 1850 |
|---|---|
| Distinct (%) | 18.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.2 KiB |
Length
| Max length | 127 |
|---|---|
| Median length | 78 |
| Mean length | 36.91605 |
| Min length | 5 |
Unique
| Unique | 91 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | Bush Somerset Collection Bookcase |
|---|---|
| 2nd row | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back |
| 3rd row | Self-Adhesive Address Labels for Typewriters by Universal |
| 4th row | Bretford CR4500 Series Slim Rectangular Table |
| 5th row | Eldon Fold 'N Roll Cart System |
| Value | Count | Frequency (%) |
| xerox | 865 | 1.5% |
| x | 701 | 1.3% |
| 599 | 1.1% | |
| with | 599 | 1.1% |
| avery | 557 | 1.0% |
| for | 539 | 1.0% |
| binders | 524 | 0.9% |
| chair | 479 | 0.9% |
| black | 426 | 0.8% |
| phone | 374 | 0.7% |
| Other values (2798) | 50371 |
Most occurring characters
| Value | Count | Frequency (%) |
| 45670 | 12.4% | |
| e | 33538 | 9.1% |
| r | 20791 | 5.6% |
| o | 19902 | 5.4% |
| a | 19064 | 5.2% |
| i | 18648 | 5.1% |
| l | 16365 | 4.4% |
| n | 15622 | 4.2% |
| s | 14683 | 4.0% |
| t | 14550 | 3.9% |
| Other values (75) | 150106 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 368939 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 45670 | 12.4% | |
| e | 33538 | 9.1% |
| r | 20791 | 5.6% |
| o | 19902 | 5.4% |
| a | 19064 | 5.2% |
| i | 18648 | 5.1% |
| l | 16365 | 4.4% |
| n | 15622 | 4.2% |
| s | 14683 | 4.0% |
| t | 14550 | 3.9% |
| Other values (75) | 150106 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 368939 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 45670 | 12.4% | |
| e | 33538 | 9.1% |
| r | 20791 | 5.6% |
| o | 19902 | 5.4% |
| a | 19064 | 5.2% |
| i | 18648 | 5.1% |
| l | 16365 | 4.4% |
| n | 15622 | 4.2% |
| s | 14683 | 4.0% |
| t | 14550 | 3.9% |
| Other values (75) | 150106 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 368939 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 45670 | 12.4% | |
| e | 33538 | 9.1% |
| r | 20791 | 5.6% |
| o | 19902 | 5.4% |
| a | 19064 | 5.2% |
| i | 18648 | 5.1% |
| l | 16365 | 4.4% |
| n | 15622 | 4.2% |
| s | 14683 | 4.0% |
| t | 14550 | 3.9% |
| Other values (75) | 150106 |
Sales
Real number (ℝ)
High correlation
| Distinct | 6144 |
|---|---|
| Distinct (%) | 61.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 229.858 |
| Minimum | 0.444 |
|---|---|
| Maximum | 22638.48 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0.444 |
|---|---|
| 5-th percentile | 4.98 |
| Q1 | 17.28 |
| median | 54.49 |
| Q3 | 209.94 |
| 95-th percentile | 956.98425 |
| Maximum | 22638.48 |
| Range | 22638.036 |
| Interquartile range (IQR) | 192.66 |
Descriptive statistics
| Standard deviation | 623.2451 |
|---|---|
| Coefficient of variation (CV) | 2.7114353 |
| Kurtosis | 305.31175 |
| Mean | 229.858 |
| Median Absolute Deviation (MAD) | 45.406 |
| Skewness | 12.972752 |
| Sum | 2297200.9 |
| Variance | 388434.46 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12.96 | 56 | 0.6% |
| 19.44 | 39 | 0.4% |
| 15.552 | 39 | 0.4% |
| 10.368 | 36 | 0.4% |
| 32.4 | 28 | 0.3% |
| 25.92 | 24 | 0.2% |
| 17.94 | 21 | 0.2% |
| 6.48 | 20 | 0.2% |
| 20.736 | 19 | 0.2% |
| 14.94 | 17 | 0.2% |
| Other values (6134) | 9695 |
| Value | Count | Frequency (%) |
| 0.444 | 1 | |
| 0.556 | 1 | |
| 0.836 | 1 | |
| 0.852 | 1 | |
| 0.876 | 1 | |
| 0.898 | 1 | |
| 0.984 | 1 | |
| 0.99 | 1 | |
| 1.044 | 1 | |
| 1.08 | 1 |
| Value | Count | Frequency (%) |
| 22638.48 | 1 | |
| 17499.95 | 1 | |
| 13999.96 | 1 | |
| 11199.968 | 1 | |
| 10499.97 | 1 | |
| 9892.74 | 1 | |
| 9449.95 | 1 | |
| 9099.93 | 1 | |
| 8749.95 | 1 | |
| 8399.976 | 1 |
Quantity
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7895737 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2251097 |
|---|---|
| Coefficient of variation (CV) | 0.58716622 |
| Kurtosis | 1.9918894 |
| Mean | 3.7895737 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.2785448 |
| Sum | 37873 |
| Variance | 4.9511131 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 3 | 2409 | |
| 2 | 2402 | |
| 5 | 1230 | |
| 4 | 1191 | |
| 1 | 899 | 9.0% |
| 7 | 606 | 6.1% |
| 6 | 572 | 5.7% |
| 9 | 258 | 2.6% |
| 8 | 257 | 2.6% |
| 10 | 57 | 0.6% |
| Other values (4) | 113 | 1.1% |
| Value | Count | Frequency (%) |
| 1 | 899 | 9.0% |
| 2 | 2402 | |
| 3 | 2409 | |
| 4 | 1191 | |
| 5 | 1230 | |
| 6 | 572 | 5.7% |
| 7 | 606 | 6.1% |
| 8 | 257 | 2.6% |
| 9 | 258 | 2.6% |
| 10 | 57 | 0.6% |
| Value | Count | Frequency (%) |
| 14 | 29 | 0.3% |
| 13 | 27 | 0.3% |
| 12 | 23 | 0.2% |
| 11 | 34 | 0.3% |
| 10 | 57 | 0.6% |
| 9 | 258 | 2.6% |
| 8 | 257 | 2.6% |
| 7 | 606 | |
| 6 | 572 | |
| 5 | 1230 |
Discount
Real number (ℝ)
High correlation Zeros
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15620272 |
| Minimum | 0 |
|---|---|
| Maximum | 0.8 |
| Zeros | 4798 |
| Zeros (%) | 48.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.2 |
| Q3 | 0.2 |
| 95-th percentile | 0.7 |
| Maximum | 0.8 |
| Range | 0.8 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.20645197 |
|---|---|
| Coefficient of variation (CV) | 1.3216925 |
| Kurtosis | 2.4095461 |
| Mean | 0.15620272 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 1.6842947 |
| Sum | 1561.09 |
| Variance | 0.042622415 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 0 | 4798 | |
| 0.2 | 3657 | |
| 0.7 | 418 | 4.2% |
| 0.8 | 300 | 3.0% |
| 0.3 | 227 | 2.3% |
| 0.4 | 206 | 2.1% |
| 0.6 | 138 | 1.4% |
| 0.1 | 94 | 0.9% |
| 0.5 | 66 | 0.7% |
| 0.15 | 52 | 0.5% |
| Other values (2) | 38 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 4798 | |
| 0.1 | 94 | 0.9% |
| 0.15 | 52 | 0.5% |
| 0.2 | 3657 | |
| 0.3 | 227 | 2.3% |
| 0.32 | 27 | 0.3% |
| 0.4 | 206 | 2.1% |
| 0.45 | 11 | 0.1% |
| 0.5 | 66 | 0.7% |
| 0.6 | 138 | 1.4% |
| Value | Count | Frequency (%) |
| 0.8 | 300 | 3.0% |
| 0.7 | 418 | 4.2% |
| 0.6 | 138 | 1.4% |
| 0.5 | 66 | 0.7% |
| 0.45 | 11 | 0.1% |
| 0.4 | 206 | 2.1% |
| 0.32 | 27 | 0.3% |
| 0.3 | 227 | 2.3% |
| 0.2 | 3657 | |
| 0.15 | 52 | 0.5% |
Profit
Real number (ℝ)
High correlation
| Distinct | 7545 |
|---|---|
| Distinct (%) | 75.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.656896 |
| Minimum | -6599.978 |
|---|---|
| Maximum | 8399.976 |
| Zeros | 65 |
| Zeros (%) | 0.7% |
| Negative | 1871 |
| Negative (%) | 18.7% |
| Memory size | 78.2 KiB |
Quantile statistics
| Minimum | -6599.978 |
|---|---|
| 5-th percentile | -53.03092 |
| Q1 | 1.72875 |
| median | 8.6665 |
| Q3 | 29.364 |
| 95-th percentile | 168.4704 |
| Maximum | 8399.976 |
| Range | 14999.954 |
| Interquartile range (IQR) | 27.63525 |
Descriptive statistics
| Standard deviation | 234.26011 |
|---|---|
| Coefficient of variation (CV) | 8.1746504 |
| Kurtosis | 397.18851 |
| Mean | 28.656896 |
| Median Absolute Deviation (MAD) | 10.77855 |
| Skewness | 7.5614316 |
| Sum | 286397.02 |
| Variance | 54877.798 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 65 | 0.7% |
| 6.2208 | 43 | 0.4% |
| 9.3312 | 38 | 0.4% |
| 3.6288 | 32 | 0.3% |
| 5.4432 | 32 | 0.3% |
| 15.552 | 26 | 0.3% |
| 12.4416 | 21 | 0.2% |
| 7.2576 | 19 | 0.2% |
| 3.1104 | 18 | 0.2% |
| 9.072 | 11 | 0.1% |
| Other values (7535) | 9689 |
| Value | Count | Frequency (%) |
| -6599.978 | 1 | |
| -3839.9904 | 1 | |
| -3701.8928 | 1 | |
| -3399.98 | 1 | |
| -2929.4845 | 1 | |
| -2639.9912 | 1 | |
| -2287.782 | 1 | |
| -1862.3124 | 1 | |
| -1850.9464 | 1 | |
| -1811.0784 | 1 |
| Value | Count | Frequency (%) |
| 8399.976 | 1 | |
| 6719.9808 | 1 | |
| 5039.9856 | 1 | |
| 4946.37 | 1 | |
| 4630.4755 | 1 | |
| 3919.9888 | 1 | |
| 3177.475 | 1 | |
| 2799.984 | 1 | |
| 2591.9568 | 1 | |
| 2504.2216 | 1 |
Interactions
Correlations
| Category | Discount | Postal Code | Profit | Quantity | Region | Row ID | Sales | Segment | Ship Mode | State | Sub-Category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Category | 1.000 | 0.377 | 0.000 | 0.056 | 0.000 | 0.000 | 0.008 | 0.072 | 0.000 | 0.000 | 0.019 | 0.999 |
| Discount | 0.377 | 1.000 | 0.053 | -0.543 | -0.001 | 0.294 | 0.013 | -0.057 | 0.005 | 0.027 | 0.354 | 0.353 |
| Postal Code | 0.000 | 0.053 | 1.000 | -0.005 | 0.014 | 0.921 | 0.011 | -0.002 | 0.035 | 0.038 | 0.968 | 0.000 |
| Profit | 0.056 | -0.543 | -0.005 | 1.000 | 0.234 | 0.021 | -0.011 | 0.518 | 0.000 | 0.005 | 0.017 | 0.130 |
| Quantity | 0.000 | -0.001 | 0.014 | 0.234 | 1.000 | 0.000 | -0.002 | 0.327 | 0.012 | 0.000 | 0.004 | 0.000 |
| Region | 0.000 | 0.294 | 0.921 | 0.021 | 0.000 | 1.000 | 0.038 | 0.000 | 0.000 | 0.022 | 0.998 | 0.000 |
| Row ID | 0.008 | 0.013 | 0.011 | -0.011 | -0.002 | 0.038 | 1.000 | -0.001 | 0.030 | 0.050 | 0.102 | 0.000 |
| Sales | 0.072 | -0.057 | -0.002 | 0.518 | 0.327 | 0.000 | -0.001 | 1.000 | 0.002 | 0.000 | 0.000 | 0.142 |
| Segment | 0.000 | 0.005 | 0.035 | 0.000 | 0.012 | 0.000 | 0.030 | 0.002 | 1.000 | 0.033 | 0.090 | 0.000 |
| Ship Mode | 0.000 | 0.027 | 0.038 | 0.005 | 0.000 | 0.022 | 0.050 | 0.000 | 0.033 | 1.000 | 0.096 | 0.007 |
| State | 0.019 | 0.354 | 0.968 | 0.017 | 0.004 | 0.998 | 0.102 | 0.000 | 0.090 | 0.096 | 1.000 | 0.000 |
| Sub-Category | 0.999 | 0.353 | 0.000 | 0.130 | 0.000 | 0.000 | 0.000 | 0.142 | 0.000 | 0.007 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | Country | City | State | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | CA-2016-152156 | 2016-11-08 | 2016-11-11 | Second Class | CG-12520 | Claire Gute | Consumer | United States | Henderson | Kentucky | 42420 | South | FUR-BO-10001798 | Furniture | Bookcases | Bush Somerset Collection Bookcase | 261.9600 | 2 | 0.00 | 41.9136 |
| 1 | 2 | CA-2016-152156 | 2016-11-08 | 2016-11-11 | Second Class | CG-12520 | Claire Gute | Consumer | United States | Henderson | Kentucky | 42420 | South | FUR-CH-10000454 | Furniture | Chairs | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back | 731.9400 | 3 | 0.00 | 219.5820 |
| 2 | 3 | CA-2016-138688 | 2016-06-12 | 2016-06-16 | Second Class | DV-13045 | Darrin Van Huff | Corporate | United States | Los Angeles | California | 90036 | West | OFF-LA-10000240 | Office Supplies | Labels | Self-Adhesive Address Labels for Typewriters by Universal | 14.6200 | 2 | 0.00 | 6.8714 |
| 3 | 4 | US-2015-108966 | 2015-10-11 | 2015-10-18 | Standard Class | SO-20335 | Sean O'Donnell | Consumer | United States | Fort Lauderdale | Florida | 33311 | South | FUR-TA-10000577 | Furniture | Tables | Bretford CR4500 Series Slim Rectangular Table | 957.5775 | 5 | 0.45 | -383.0310 |
| 4 | 5 | US-2015-108966 | 2015-10-11 | 2015-10-18 | Standard Class | SO-20335 | Sean O'Donnell | Consumer | United States | Fort Lauderdale | Florida | 33311 | South | OFF-ST-10000760 | Office Supplies | Storage | Eldon Fold 'N Roll Cart System | 22.3680 | 2 | 0.20 | 2.5164 |
| 5 | 6 | CA-2014-115812 | 2014-06-09 | 2014-06-14 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | FUR-FU-10001487 | Furniture | Furnishings | Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood | 48.8600 | 7 | 0.00 | 14.1694 |
| 6 | 7 | CA-2014-115812 | 2014-06-09 | 2014-06-14 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | OFF-AR-10002833 | Office Supplies | Art | Newell 322 | 7.2800 | 4 | 0.00 | 1.9656 |
| 7 | 8 | CA-2014-115812 | 2014-06-09 | 2014-06-14 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | TEC-PH-10002275 | Technology | Phones | Mitel 5320 IP Phone VoIP phone | 907.1520 | 6 | 0.20 | 90.7152 |
| 8 | 9 | CA-2014-115812 | 2014-06-09 | 2014-06-14 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | OFF-BI-10003910 | Office Supplies | Binders | DXL Angle-View Binders with Locking Rings by Samsill | 18.5040 | 3 | 0.20 | 5.7825 |
| 9 | 10 | CA-2014-115812 | 2014-06-09 | 2014-06-14 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | OFF-AP-10002892 | Office Supplies | Appliances | Belkin F5C206VTEL 6 Outlet Surge | 114.9000 | 5 | 0.00 | 34.4700 |
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | Country | City | State | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9984 | 9985 | CA-2015-100251 | 2015-05-17 | 2015-05-23 | Standard Class | DV-13465 | Dianna Vittorini | Consumer | United States | Long Beach | New York | 11561 | East | OFF-LA-10003766 | Office Supplies | Labels | Self-Adhesive Removable Labels | 31.500 | 10 | 0.0 | 15.1200 |
| 9985 | 9986 | CA-2015-100251 | 2015-05-17 | 2015-05-23 | Standard Class | DV-13465 | Dianna Vittorini | Consumer | United States | Long Beach | New York | 11561 | East | OFF-SU-10000898 | Office Supplies | Supplies | Acme Hot Forged Carbon Steel Scissors with Nickel-Plated Handles, 3 7/8" Cut, 8"L | 55.600 | 4 | 0.0 | 16.1240 |
| 9986 | 9987 | CA-2016-125794 | 2016-09-29 | 2016-10-03 | Standard Class | ML-17410 | Maris LaWare | Consumer | United States | Los Angeles | California | 90008 | West | TEC-AC-10003399 | Technology | Accessories | Memorex Mini Travel Drive 64 GB USB 2.0 Flash Drive | 36.240 | 1 | 0.0 | 15.2208 |
| 9987 | 9988 | CA-2017-163629 | 2017-11-17 | 2017-11-21 | Standard Class | RA-19885 | Ruben Ausman | Corporate | United States | Athens | Georgia | 30605 | South | TEC-AC-10001539 | Technology | Accessories | Logitech G430 Surround Sound Gaming Headset with Dolby 7.1 Technology | 79.990 | 1 | 0.0 | 28.7964 |
| 9988 | 9989 | CA-2017-163629 | 2017-11-17 | 2017-11-21 | Standard Class | RA-19885 | Ruben Ausman | Corporate | United States | Athens | Georgia | 30605 | South | TEC-PH-10004006 | Technology | Phones | Panasonic KX - TS880B Telephone | 206.100 | 5 | 0.0 | 55.6470 |
| 9989 | 9990 | CA-2014-110422 | 2014-01-21 | 2014-01-23 | Second Class | TB-21400 | Tom Boeckenhauer | Consumer | United States | Miami | Florida | 33180 | South | FUR-FU-10001889 | Furniture | Furnishings | Ultra Door Pull Handle | 25.248 | 3 | 0.2 | 4.1028 |
| 9990 | 9991 | CA-2017-121258 | 2017-02-26 | 2017-03-03 | Standard Class | DB-13060 | Dave Brooks | Consumer | United States | Costa Mesa | California | 92627 | West | FUR-FU-10000747 | Furniture | Furnishings | Tenex B1-RE Series Chair Mats for Low Pile Carpets | 91.960 | 2 | 0.0 | 15.6332 |
| 9991 | 9992 | CA-2017-121258 | 2017-02-26 | 2017-03-03 | Standard Class | DB-13060 | Dave Brooks | Consumer | United States | Costa Mesa | California | 92627 | West | TEC-PH-10003645 | Technology | Phones | Aastra 57i VoIP phone | 258.576 | 2 | 0.2 | 19.3932 |
| 9992 | 9993 | CA-2017-121258 | 2017-02-26 | 2017-03-03 | Standard Class | DB-13060 | Dave Brooks | Consumer | United States | Costa Mesa | California | 92627 | West | OFF-PA-10004041 | Office Supplies | Paper | It's Hot Message Books with Stickers, 2 3/4" x 5" | 29.600 | 4 | 0.0 | 13.3200 |
| 9993 | 9994 | CA-2017-119914 | 2017-05-04 | 2017-05-09 | Second Class | CC-12220 | Chris Cortes | Consumer | United States | Westminster | California | 92683 | West | OFF-AP-10002684 | Office Supplies | Appliances | Acco 7-Outlet Masterpiece Power Center, Wihtout Fax/Phone Line Protection | 243.160 | 2 | 0.0 | 72.9480 |